﻿CREATE TABLE [dbo].[GrileOcupatiiDep] (
    [IDGrilaOcupatie] SMALLINT        IDENTITY (1, 1) NOT NULL,
    [IDOcupatie]      INT             NOT NULL,
    [IDDepartament]   INT             NOT NULL,
    [Valoare]         DECIMAL (18, 2) NOT NULL,
    [IDTipSpor]       INT             NULL,
    CONSTRAINT [PK_GrilaOcupatiiDep] PRIMARY KEY CLUSTERED ([IDGrilaOcupatie] ASC),
    CONSTRAINT [FK_GrileOcupatiiDep_Departamente] FOREIGN KEY ([IDDepartament]) REFERENCES [dbo].[Departamente] ([IDDepartament]),
    CONSTRAINT [FK_GrileOcupatiiDep_Ocupatii] FOREIGN KEY ([IDOcupatie]) REFERENCES [dbo].[Ocupatii] ([IDOcupatie]),
    CONSTRAINT [FK_GrileOcupatiiDep_TipSpor] FOREIGN KEY ([IDTipSpor]) REFERENCES [dbo].[TipSpor] ([IDTipSpor])
);

